www.gusucode.com > 深度学习(asp)网址导航 v4.0.1 > 深度学习(asp)网址导航 v4.0.1\code\admin\dataManage\data_SQL.asp
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<%
projectRootPath = "../../" '相对当前应用程序根的位置
%>
<!-- #include file ="../include/checkPurview.asp"-->
<!--#include file="../../ConnDB.asp"-->
<!-- #include file="../include/Function.Manage.Config.asp"-->
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta name="robots" content="noindex,nofollow" />
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>数据管理</title>
<link rel="stylesheet" type="text/css" href="../themes/base.css"/>
<link href="../themes/<%=theme_Path%>/main.css" rel="stylesheet" type="text/css" />
</head>
</head>
<body id="bodyBg1">
<br />
<a href="data_SQL.asp">批量处理数据</a>
<hr class="Nav-hr" />
<br />
<dl class="manageContent">
<dt>批量处理数据</dt>
<dd>
<br />
<%
if request("action") = "save" then
SQL_Statement=Request("SQL_Statement")
if SQL_Statement<>Empty then
On Error Resume Next
conn.Execute(SQL_Statement)
if err.number="0" then
response.write "[" & SQL_Statement &"] <br />执行成功！<br />"
else
errmsg = "[" & SQL_Statement &"] <li>语句有问题，具体出错如下：<br />"
errmsg = errmsg & Err.Description &"<br />"
err.clear
response.write errmsg
end if
end if
end if
%>
<br />
<form name="FormPst" Method="post" Action="">
<fieldset>
<legend>请输入SQL语句</legend>
指令：
<input type="text" name="SQL_Statement" Size="80" />
<input type="submit" Value="执行" />
<input type="hidden" name="action" value="save" />
</fieldset>
</form>
<br />
SQL语句执行操作：本操作仅限高级、对SQL编程比较熟悉的用户，您可以直接输入sql执行语句，比如delete from info where id=2 进行删除等操作，在操作前请慎重考虑您的执行语句是否正确和完整，执行后不可恢复。
<br />
</dd>
</dl>
<br />
</body>
</html>
<%
Call CloseConnDB()
%>